package com.chinatelecom.otms.circuitcheck.mapper;

import com.chinatelecom.otms.circuitcheck.entity.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface CheckCircuitMapper {

    List<CheckCircuit> getAllCheckCircuitList();

    int insertCheckCircuitListByList(List<CheckCircuit> list, @Param("table_name") String table_name);

    int updateAZConstrastResultByList(AZConstrastResult azConstrastResult);

    void truncateTable(@Param("table_name") String table_name);

    List<CheckCircuit> executeConnectByRootSql(List<String> list);

    List<CheckCarrierAndSncRouteResult> checkCarrierAndSncRoute(String snc_id);

    List<FDFRCarrierResult> checkFDFRinCarrier(String snc_id);

    List<MFDFRPortResult> checkMFDFRPort(String snc_id);

    List<MFDFRPortResult> checkMFDFRPortPTP(String snc_id);

    List<CheckFDFRRouteInSncAndMFDFRResult> checkFDFRRouteInSncAndMFDFR(String snc_id);

    List<CheckL2LinkRouteResult> checkL2LinkRoute(String snc_id);

    List<L2LinkTempResult> getAZPortByobjId(String snc_id);

    List<L2LinkTempResult> getAZPortBySncId(String snc_id);

    List<CheckPortStateVlanResult> checkPortStateVlan(String snc_id);

    List<CheckBindingRelResult> checkBindingRel(String snc_id);

    List<CheckFTPBindingRelResult> checkFTPBindingRel(String snc_id);

    List<User> selectUser();
}
